/*
 Navicat MySQL Data Transfer

 Source Server         : localhost
 Source Server Version : 50542
 Source Host           : localhost
 Source Database       : kfsy_channel_store

 Target Server Version : 50542
 File Encoding         : utf-8

 Date: 09/29/2017 19:53:21 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `kf_channel_product_thumb`
-- ----------------------------
DROP TABLE IF EXISTS `kf_channel_product_thumb`;
CREATE TABLE `kf_channel_product_thumb` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fk_channel_id` int(11) NOT NULL DEFAULT '0' COMMENT '第三方渠道id',
  `fk_store_id` int(11) NOT NULL DEFAULT '0' COMMENT '快方药店id',
  `fk_product_id` int(11) NOT NULL DEFAULT '0' COMMENT '快方商品id',
  `thumb_href` varchar(500) NOT NULL DEFAULT '' COMMENT '图片路径地址',
  `createtime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '数据创建时间',
  `updatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '数据最后更新时间',
  PRIMARY KEY (`id`),
  KEY `channel_store` (`fk_channel_id`,`fk_store_id`),
  KEY `product` (`fk_product_id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Records of `kf_channel_product_thumb`
-- ----------------------------
BEGIN;
INSERT INTO `kf_channel_product_thumb` VALUES ('5', '2', '3', '19', 'http://p1.kfyao.com/78/98/7898140821161413143.jpg', '2017-09-29 14:38:41', '2017-09-29 14:38:41'), ('6', '2', '3', '19', 'http://p1.kfyao.com/61/80/6180140821161413680.jpg', '2017-09-29 14:38:41', '2017-09-29 14:38:41'), ('7', '2', '3', '19', 'http://p1.kfyao.com/29/61/2961140821161413810.jpg', '2017-09-29 14:38:41', '2017-09-29 14:38:41'), ('8', '2', '3', '19', 'http://p1.kfyao.com/91/34/9134140821161413665.jpg', '2017-09-29 14:38:41', '2017-09-29 14:38:41'), ('9', '2', '3', '4', 'http://p1.kfyao.com/93/55/9355140821184823748.jpg', '2017-09-29 14:47:11', '2017-09-29 14:47:11'), ('10', '2', '3', '4', 'http://p1.kfyao.com/18/82/1882140821184824700.jpg', '2017-09-29 14:47:11', '2017-09-29 14:47:11'), ('11', '2', '3', '4', 'http://p1.kfyao.com/90/64/9064140821184824966.jpg', '2017-09-29 14:47:11', '2017-09-29 14:47:11'), ('12', '2', '3', '4', 'http://p1.kfyao.com/74/60/7460140821184824481.jpg', '2017-09-29 14:47:11', '2017-09-29 14:47:11'), ('13', '2', '3', '1505', 'http://p1.kfyao.com/68/43/6843140822103205176.jpg', '2017-09-29 14:51:54', '2017-09-29 14:51:54'), ('14', '2', '3', '1505', 'http://p1.kfyao.com/32/64/3264140822103205391.jpg', '2017-09-29 14:51:54', '2017-09-29 14:51:54'), ('15', '2', '3', '1505', 'http://p1.kfyao.com/48/36/4836140822103205686.jpg', '2017-09-29 14:51:54', '2017-09-29 14:51:54'), ('16', '2', '3', '1505', 'http://p1.kfyao.com/82/70/8270140822103205575.jpg', '2017-09-29 14:51:54', '2017-09-29 14:51:54'), ('17', '2', '3', '1506', 'http://p1.kfyao.com/13/32/1332150314114917521.jpg', '2017-09-29 14:52:28', '2017-09-29 14:52:28'), ('18', '2', '3', '1506', 'http://p1.kfyao.com/69/43/6943150314114917303.jpg', '2017-09-29 14:52:28', '2017-09-29 14:52:28'), ('19', '2', '3', '1510', 'http://p1.kfyao.com/10/62/1062140611132836365.jpg', '2017-09-29 14:58:57', '2017-09-29 14:58:57'), ('20', '2', '3', '1510', 'http://p1.kfyao.com/33/97/3397140611132836722.jpg', '2017-09-29 14:58:57', '2017-09-29 14:58:57'), ('21', '2', '3', '1510', 'http://p1.kfyao.com/24/56/2456140611132836184.jpg', '2017-09-29 14:58:57', '2017-09-29 14:58:57'), ('22', '2', '3', '1510', 'http://p1.kfyao.com/68/55/6855140611132836759.jpg', '2017-09-29 14:58:57', '2017-09-29 14:58:57'), ('23', '2', '3', '1512', 'http://p1.kfyao.com/66/85/6685140723102312469.jpg', '2017-09-29 14:59:30', '2017-09-29 14:59:30'), ('24', '2', '3', '1512', 'http://p1.kfyao.com/79/73/7973140723102312604.jpg', '2017-09-29 14:59:30', '2017-09-29 14:59:30'), ('25', '2', '3', '1512', 'http://p1.kfyao.com/72/91/7291140723102312336.jpg', '2017-09-29 14:59:30', '2017-09-29 14:59:30'), ('26', '2', '3', '1512', 'http://p1.kfyao.com/31/50/3150140723102313834.jpg', '2017-09-29 14:59:30', '2017-09-29 14:59:30');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
